|
|
|
|
|
|
|
|
ProgressBar (Property) In french: Jauge
The ProgressBar property is used to identify and change the Progress Bar control used when calculating a Pivot Table control ( PVTCalculateAll and PVTCalculateUpdate functions). PVT_Sales.ProgressBar = PROGBAR_PVTSales.Name
PVTCalculateAll(PVT_Sales)
Syntax
Identifying the progress bar used for calculating a Pivot Table control Hide the details
<Result> = <Pivot Table control>.ProgressBar
<Result>: Character string - Name of the Progress Bar control used.
- Empty string ("") if the automatic progress bar of the Pivot Table control is used.
<Pivot Table control>: Control name Name of Pivot Table control.
Changing the progress bar used for calculating a Pivot Table control Hide the details
<Pivot Table control>.ProgressBar = <New Progress Bar>
<Pivot Table control>: Control name Name of the Pivot Table control to be used. <New Progress Bar>: Character string New name of the progress bar to use. This name can correspond to: - the name of a Progress Bar control (Name property used on the Progress Bar control).
- an empty string ("") if the automatic progress bar of the Pivot Table control must be used.
Remarks - Progress Bar status bars cannot be used.
- If the Progress Bar control is invisible, it is automatically made visible during the calculation then it becomes invisible at the end of calculation.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|